Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 89505 |
| Missing cells | 179010 |
| Missing cells (%) | 8.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 17.1 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Categorical | 3 |
|---|---|
| Text | 2 |
| Unsupported | 2 |
| Numeric | 17 |
| DateTime | 1 |
Crawled_date has constant value "2024-12-05 00:00:00" | Constant |
Average_Rating is highly overall correlated with Hotel_Name and 6 other fields | High correlation |
FOG Index is highly overall correlated with Flesch Reading Ease | High correlation |
Flesch Reading Ease is highly overall correlated with FOG Index | High correlation |
Hotel_Name is highly overall correlated with Average_Rating and 8 other fields | High correlation |
Num_of_Ratings is highly overall correlated with Hotel_Name and 1 other fields | High correlation |
breadth is highly overall correlated with depth and 1 other fields | High correlation |
cleanliness_score is highly overall correlated with Average_Rating and 6 other fields | High correlation |
comfort_score is highly overall correlated with Average_Rating and 5 other fields | High correlation |
depth is highly overall correlated with breadth | High correlation |
employee_friendliness_score is highly overall correlated with Average_Rating and 5 other fields | High correlation |
facility_score is highly overall correlated with Average_Rating and 6 other fields | High correlation |
hotel_grade is highly overall correlated with Average_Rating and 4 other fields | High correlation |
location_score is highly overall correlated with Hotel_Name | High correlation |
text_length is highly overall correlated with breadth | High correlation |
value_for_money_score is highly overall correlated with Average_Rating and 5 other fields | High correlation |
is_photo is highly imbalanced (71.3%) | Imbalance |
Posted_Date has 89505 (100.0%) missing values | Missing |
time_lapsed has 89505 (100.0%) missing values | Missing |
Posted_Date is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
time_lapsed is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Helpfulness has 81272 (90.8%) zeros | Zeros |
Deviation of star ratings has 2451 (2.7%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-05 09:16:33.192033 |
|---|---|
| Analysis finished | 2025-02-05 09:17:04.503587 |
| Duration | 31.31 seconds |
| Software version | ydata-profiling vv4.12.1 |
| Download configuration | config.json |
Variables
Hotel_Name
Categorical
High correlation
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
| thistletower | 4646 |
|---|---|
| lancaster-gate | 4637 |
| zedwell-trocaderor | 4632 |
| stgileshotel | 4621 |
| z-trafalgar | 4392 |
| Other values (28) |
Length
| Max length | 35 |
|---|---|
| Median length | 22 |
| Mean length | 15.818826 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | studios2let |
|---|---|
| 2nd row | studios2let |
| 3rd row | studios2let |
| 4th row | studios2let |
| 5th row | studios2let |
Common Values
| Value | Count | Frequency (%) |
| thistletower | 4646 | 5.2% |
| lancaster-gate | 4637 | 5.2% |
| zedwell-trocaderor | 4632 | 5.2% |
| stgileshotel | 4621 | 5.2% |
| z-trafalgar | 4392 | 4.9% |
| nyx-hotel-london-by-leonardo-hotels | 3567 | 4.0% |
| radissonblugrafton | 3472 | 3.9% |
| sidneyhotel | 3316 | 3.7% |
| studios2let | 3294 | 3.7% |
| montcalm-chilworth-townhouse | 3134 | 3.5% |
| Other values (23) | 49794 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| thistletower | 4646 | 5.2% |
| lancaster-gate | 4637 | 5.2% |
| zedwell-trocaderor | 4632 | 5.2% |
| stgileshotel | 4621 | 5.2% |
| z-trafalgar | 4392 | 4.9% |
| nyx-hotel-london-by-leonardo-hotels | 3567 | 4.0% |
| radissonblugrafton | 3472 | 3.9% |
| sidneyhotel | 3316 | 3.7% |
| studios2let | 3294 | 3.7% |
| montcalm-chilworth-townhouse | 3134 | 3.5% |
| Other values (23) | 49794 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 152385 | |
| t | 144243 | |
| o | 143989 | |
| l | 125444 | 8.9% |
| a | 104620 | 7.4% |
| r | 99022 | 7.0% |
| n | 85007 | 6.0% |
| s | 79298 | 5.6% |
| - | 71310 | 5.0% |
| h | 63778 | 4.5% |
| Other values (16) | 346768 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1415864 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 152385 | |
| t | 144243 | |
| o | 143989 | |
| l | 125444 | 8.9% |
| a | 104620 | 7.4% |
| r | 99022 | 7.0% |
| n | 85007 | 6.0% |
| s | 79298 | 5.6% |
| - | 71310 | 5.0% |
| h | 63778 | 4.5% |
| Other values (16) | 346768 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1415864 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 152385 | |
| t | 144243 | |
| o | 143989 | |
| l | 125444 | 8.9% |
| a | 104620 | 7.4% |
| r | 99022 | 7.0% |
| n | 85007 | 6.0% |
| s | 79298 | 5.6% |
| - | 71310 | 5.0% |
| h | 63778 | 4.5% |
| Other values (16) | 346768 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1415864 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 152385 | |
| t | 144243 | |
| o | 143989 | |
| l | 125444 | 8.9% |
| a | 104620 | 7.4% |
| r | 99022 | 7.0% |
| n | 85007 | 6.0% |
| s | 79298 | 5.6% |
| - | 71310 | 5.0% |
| h | 63778 | 4.5% |
| Other values (16) | 346768 |
Review_Text
Text
| Distinct | 89496 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
Length
| Max length | 3585 |
|---|---|
| Median length | 1848 |
| Mean length | 206.82469 |
| Min length | 1 |
Unique
| Unique | 89487 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | Perfect location with good connections and shops and pubs |
|---|---|
| 2nd row | The room had everything you needed. Near to amenities, was good room for price just needs little updatingThe bed was so hard it felt like sleeping on a hard floor, you had to make sure you had something on your feet as flooring pinched you feet needs changing |
| 3rd row | Conveniently nearby St. Pancras, very small but clean and pleasant room (first floor with small balcony to street side). Interesting area.Luggage service can be improved by offering to lock luggage up instead of it just being put into the hall with all risks on the guests. |
| 4th row | Reception staffed 24 hours a day.All good. |
| 5th row | Very convenient to Kings Cross and the cityA little dated could do with a lick of paint |
| Value | Count | Frequency (%) |
| the | 180331 | 5.5% |
| and | 125772 | 3.9% |
| was | 105752 | 3.2% |
| to | 81103 | 2.5% |
| a | 76989 | 2.4% |
| room | 60919 | 1.9% |
| in | 52248 | 1.6% |
| very | 46600 | 1.4% |
| for | 42764 | 1.3% |
| location | 42032 | 1.3% |
| Other values (73950) | 2440724 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3170061 | ||
| e | 1741276 | 9.4% |
| o | 1349668 | 7.3% |
| t | 1305837 | 7.1% |
| a | 1265869 | 6.8% |
| n | 973710 | 5.3% |
| r | 886563 | 4.8% |
| i | 873286 | 4.7% |
| s | 820340 | 4.4% |
| l | 706295 | 3.8% |
| Other values (65) | 5418939 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18511844 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3170061 | ||
| e | 1741276 | 9.4% |
| o | 1349668 | 7.3% |
| t | 1305837 | 7.1% |
| a | 1265869 | 6.8% |
| n | 973710 | 5.3% |
| r | 886563 | 4.8% |
| i | 873286 | 4.7% |
| s | 820340 | 4.4% |
| l | 706295 | 3.8% |
| Other values (65) | 5418939 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18511844 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3170061 | ||
| e | 1741276 | 9.4% |
| o | 1349668 | 7.3% |
| t | 1305837 | 7.1% |
| a | 1265869 | 6.8% |
| n | 973710 | 5.3% |
| r | 886563 | 4.8% |
| i | 873286 | 4.7% |
| s | 820340 | 4.4% |
| l | 706295 | 3.8% |
| Other values (65) | 5418939 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18511844 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3170061 | ||
| e | 1741276 | 9.4% |
| o | 1349668 | 7.3% |
| t | 1305837 | 7.1% |
| a | 1265869 | 6.8% |
| n | 973710 | 5.3% |
| r | 886563 | 4.8% |
| i | 873286 | 4.7% |
| s | 820340 | 4.4% |
| l | 706295 | 3.8% |
| Other values (65) | 5418939 |
Posted_Date
Unsupported
Missing Rejected Unsupported
| Missing | 89505 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 699.4 KiB |
Rating
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.714235 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 7 |
| median | 8 |
| Q3 | 9 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.9163799 |
|---|---|
| Coefficient of variation (CV) | 0.24842125 |
| Kurtosis | 1.9857144 |
| Mean | 7.714235 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.2857857 |
| Sum | 690462.6 |
| Variance | 3.672512 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=24)
| Value | Count | Frequency (%) |
| 8 | 26129 | |
| 9 | 16479 | |
| 10 | 15234 | |
| 7 | 14990 | |
| 6 | 6451 | 7.2% |
| 5 | 3941 | 4.4% |
| 4 | 2183 | 2.4% |
| 3 | 1656 | 1.9% |
| 1 | 1573 | 1.8% |
| 2 | 799 | 0.9% |
| Other values (14) | 70 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1573 | 1.8% |
| 2 | 799 | 0.9% |
| 2.5 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 3 | 1656 | |
| 4 | 2183 | |
| 4.6 | 1 | < 0.1% |
| 5 | 3941 | |
| 5.4 | 2 | < 0.1% |
| 5.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 15234 | |
| 9.6 | 15 | < 0.1% |
| 9.2 | 12 | < 0.1% |
| 9 | 16479 | |
| 8.8 | 7 | < 0.1% |
| 8.3 | 7 | < 0.1% |
| 8 | 26129 | |
| 7.9 | 7 | < 0.1% |
| 7.5 | 5 | < 0.1% |
| 7.1 | 3 | < 0.1% |
Average_Rating
Real number (ℝ)
High correlation
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8322563 |
| Minimum | 7 |
|---|---|
| Maximum | 8.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 7.6 |
| median | 7.7 |
| Q3 | 8.1 |
| 95-th percentile | 8.6 |
| Maximum | 8.7 |
| Range | 1.7 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.42988557 |
|---|---|
| Coefficient of variation (CV) | 0.054886556 |
| Kurtosis | -0.37402998 |
| Mean | 7.8322563 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 0.068699345 |
| Sum | 701026.1 |
| Variance | 0.1848016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 7.7 | 21807 | |
| 7.8 | 8749 | |
| 8.4 | 7959 | 8.9% |
| 7.9 | 7510 | 8.4% |
| 7.4 | 7313 | 8.2% |
| 7 | 6497 | 7.3% |
| 8.3 | 5300 | 5.9% |
| 7.6 | 5222 | 5.8% |
| 8.6 | 4480 | 5.0% |
| 8 | 4100 | 4.6% |
| Other values (5) | 10568 |
| Value | Count | Frequency (%) |
| 7 | 6497 | 7.3% |
| 7.1 | 1907 | 2.1% |
| 7.4 | 7313 | 8.2% |
| 7.5 | 2065 | 2.3% |
| 7.6 | 5222 | 5.8% |
| 7.7 | 21807 | |
| 7.8 | 8749 | |
| 7.9 | 7510 | 8.4% |
| 8 | 4100 | 4.6% |
| 8.1 | 2409 | 2.7% |
| Value | Count | Frequency (%) |
| 8.7 | 2423 | 2.7% |
| 8.6 | 4480 | 5.0% |
| 8.4 | 7959 | 8.9% |
| 8.3 | 5300 | 5.9% |
| 8.2 | 1764 | 2.0% |
| 8.1 | 2409 | 2.7% |
| 8 | 4100 | 4.6% |
| 7.9 | 7510 | 8.4% |
| 7.8 | 8749 | |
| 7.7 | 21807 |
Num_of_Ratings
Real number (ℝ)
High correlation
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11821.248 |
| Minimum | 5613 |
|---|---|
| Maximum | 39497 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 5613 |
|---|---|
| 5-th percentile | 5898 |
| Q1 | 6664 |
| median | 9394 |
| Q3 | 13923 |
| 95-th percentile | 39497 |
| Maximum | 39497 |
| Range | 33884 |
| Interquartile range (IQR) | 7259 |
Descriptive statistics
| Standard deviation | 7556.399 |
|---|---|
| Coefficient of variation (CV) | 0.63922176 |
| Kurtosis | 6.5265364 |
| Mean | 11821.248 |
| Median Absolute Deviation (MAD) | 3059 |
| Skewness | 2.5057259 |
| Sum | 1.0580608 × 109 |
| Variance | 57099167 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 20956 | 4646 | 5.2% |
| 14445 | 4637 | 5.2% |
| 39497 | 4632 | 5.2% |
| 14989 | 4621 | 5.2% |
| 13923 | 4392 | 4.9% |
| 9394 | 3567 | 4.0% |
| 9315 | 3472 | 3.9% |
| 12641 | 3316 | 3.7% |
| 11670 | 3294 | 3.7% |
| 9205 | 3134 | 3.5% |
| Other values (23) | 49794 |
| Value | Count | Frequency (%) |
| 5613 | 1780 | |
| 5715 | 1836 | |
| 5898 | 1764 | |
| 5932 | 2135 | |
| 5933 | 2256 | |
| 6120 | 1928 | |
| 6248 | 1619 | |
| 6277 | 2297 | |
| 6335 | 2002 | |
| 6404 | 1876 |
| Value | Count | Frequency (%) |
| 39497 | 4632 | |
| 20956 | 4646 | |
| 15320 | 2681 | |
| 14989 | 4621 | |
| 14445 | 4637 | |
| 13923 | 4392 | |
| 12641 | 3316 | |
| 12340 | 2795 | |
| 11670 | 3294 | |
| 11045 | 2644 |
Helpfulness
Real number (ℝ)
Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10799397 |
| Minimum | 0 |
|---|---|
| Maximum | 14 |
| Zeros | 81272 |
| Zeros (%) | 90.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 14 |
| Range | 14 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.37722244 |
|---|---|
| Coefficient of variation (CV) | 3.4929955 |
| Kurtosis | 60.928616 |
| Mean | 0.10799397 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.3359025 |
| Sum | 9666 |
| Variance | 0.14229677 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 0 | 81272 | |
| 1 | 7145 | 8.0% |
| 2 | 870 | 1.0% |
| 3 | 152 | 0.2% |
| 4 | 36 | < 0.1% |
| 5 | 18 | < 0.1% |
| 6 | 7 | < 0.1% |
| 10 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 81272 | |
| 1 | 7145 | 8.0% |
| 2 | 870 | 1.0% |
| 3 | 152 | 0.2% |
| 4 | 36 | < 0.1% |
| 5 | 18 | < 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 14 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 7 | < 0.1% |
| 5 | 18 | < 0.1% |
| 4 | 36 | < 0.1% |
| 3 | 152 | 0.2% |
| 2 | 870 | 1.0% |
| 1 | 7145 |
is_photo
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
| 0 | |
|---|---|
| 1 | 4496 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 85009 | |
| 1 | 4496 | 5.0% |
review_title
Text
| Distinct | 49587 |
|---|---|
| Distinct (%) | 55.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
Length
| Max length | 120 |
|---|---|
| Median length | 105 |
| Mean length | 29.705257 |
| Min length | 1 |
Unique
| Unique | 47408 ? |
|---|---|
| Unique (%) | 53.0% |
Sample
| 1st row | Exceptional |
|---|---|
| 2nd row | Very good |
| 3rd row | Convenient location |
| 4th row | Peaceful position in an elegant street close to 3 major stations and the Bloomsbury area. |
| 5th row | Great little gem in the city centre |
| Value | Count | Frequency (%) |
| good | 24889 | 5.4% |
| location | 16216 | 3.5% |
| and | 15769 | 3.4% |
| very | 15704 | 3.4% |
| great | 14151 | 3.1% |
| stay | 13440 | 2.9% |
| a | 12645 | 2.8% |
| for | 11823 | 2.6% |
| the | 11114 | 2.4% |
| hotel | 10706 | 2.3% |
| Other values (10150) | 310791 |
Most occurring characters
| Value | Count | Frequency (%) |
| 369129 | ||
| e | 248614 | 9.4% |
| o | 234581 | 8.8% |
| a | 197441 | 7.4% |
| t | 191728 | 7.2% |
| n | 149773 | 5.6% |
| l | 128796 | 4.8% |
| r | 128006 | 4.8% |
| i | 122655 | 4.6% |
| s | 92044 | 3.5% |
| Other values (63) | 796002 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2658769 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 369129 | ||
| e | 248614 | 9.4% |
| o | 234581 | 8.8% |
| a | 197441 | 7.4% |
| t | 191728 | 7.2% |
| n | 149773 | 5.6% |
| l | 128796 | 4.8% |
| r | 128006 | 4.8% |
| i | 122655 | 4.6% |
| s | 92044 | 3.5% |
| Other values (63) | 796002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2658769 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 369129 | ||
| e | 248614 | 9.4% |
| o | 234581 | 8.8% |
| a | 197441 | 7.4% |
| t | 191728 | 7.2% |
| n | 149773 | 5.6% |
| l | 128796 | 4.8% |
| r | 128006 | 4.8% |
| i | 122655 | 4.6% |
| s | 92044 | 3.5% |
| Other values (63) | 796002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2658769 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 369129 | ||
| e | 248614 | 9.4% |
| o | 234581 | 8.8% |
| a | 197441 | 7.4% |
| t | 191728 | 7.2% |
| n | 149773 | 5.6% |
| l | 128796 | 4.8% |
| r | 128006 | 4.8% |
| i | 122655 | 4.6% |
| s | 92044 | 3.5% |
| Other values (63) | 796002 |
hotel_grade
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
| 4 | |
|---|---|
| 3 | |
| 5 | |
| 0 | |
| 2 | 2034 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 3 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 89505 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 39990 | |
| 3 | 36148 | |
| 5 | 6701 | 7.5% |
| 0 | 4632 | 5.2% |
| 2 | 2034 | 2.3% |
employee_friendliness_score
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5347634 |
| Minimum | 7.5 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 7.5 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 8.3 |
| median | 8.6 |
| Q3 | 8.7 |
| 95-th percentile | 9.1 |
| Maximum | 9.1 |
| Range | 1.6 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.36889506 |
|---|---|
| Coefficient of variation (CV) | 0.043222647 |
| Kurtosis | 0.69953941 |
| Mean | 8.5347634 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.7107023 |
| Sum | 763904 |
| Variance | 0.13608357 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 8.7 | 18186 | |
| 8.6 | 13683 | |
| 8.1 | 9253 | |
| 8.4 | 8871 | |
| 9.1 | 8651 | |
| 8.5 | 6722 | 7.5% |
| 9 | 6027 | 6.7% |
| 8.3 | 5359 | 6.0% |
| 8.8 | 4287 | 4.8% |
| 7.5 | 3783 | 4.2% |
| Other values (2) | 4683 | 5.2% |
| Value | Count | Frequency (%) |
| 7.5 | 3783 | 4.2% |
| 8 | 2681 | 3.0% |
| 8.1 | 9253 | |
| 8.2 | 2002 | 2.2% |
| 8.3 | 5359 | 6.0% |
| 8.4 | 8871 | |
| 8.5 | 6722 | 7.5% |
| 8.6 | 13683 | |
| 8.7 | 18186 | |
| 8.8 | 4287 | 4.8% |
| Value | Count | Frequency (%) |
| 9.1 | 8651 | |
| 9 | 6027 | 6.7% |
| 8.8 | 4287 | 4.8% |
| 8.7 | 18186 | |
| 8.6 | 13683 | |
| 8.5 | 6722 | 7.5% |
| 8.4 | 8871 | |
| 8.3 | 5359 | 6.0% |
| 8.2 | 2002 | 2.2% |
| 8.1 | 9253 |
facility_score
Real number (ℝ)
High correlation
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.8393822 |
| Minimum | 6.9 |
|---|---|
| Maximum | 8.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 6.9 |
|---|---|
| 5-th percentile | 6.9 |
| Q1 | 7.5 |
| median | 7.8 |
| Q3 | 8.3 |
| 95-th percentile | 8.7 |
| Maximum | 8.7 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.8 |
Descriptive statistics
| Standard deviation | 0.50174873 |
|---|---|
| Coefficient of variation (CV) | 0.064003606 |
| Kurtosis | -0.73232438 |
| Mean | 7.8393822 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | 0.074828239 |
| Sum | 701663.9 |
| Variance | 0.25175179 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 7.8 | 12069 | |
| 7.5 | 11924 | |
| 7.6 | 8815 | |
| 8.7 | 8634 | |
| 6.9 | 6497 | 7.3% |
| 8.3 | 5696 | 6.4% |
| 8 | 5570 | 6.2% |
| 7.2 | 4632 | 5.2% |
| 8.4 | 4392 | 4.9% |
| 7.7 | 3916 | 4.4% |
| Other values (7) | 17360 |
| Value | Count | Frequency (%) |
| 6.9 | 6497 | |
| 7.2 | 4632 | 5.2% |
| 7.3 | 1907 | 2.1% |
| 7.4 | 2681 | 3.0% |
| 7.5 | 11924 | |
| 7.6 | 8815 | |
| 7.7 | 3916 | 4.4% |
| 7.8 | 12069 | |
| 7.9 | 2256 | 2.5% |
| 8 | 5570 |
| Value | Count | Frequency (%) |
| 8.7 | 8634 | |
| 8.6 | 1836 | 2.1% |
| 8.5 | 2505 | 2.8% |
| 8.4 | 4392 | 4.9% |
| 8.3 | 5696 | |
| 8.2 | 2409 | 2.7% |
| 8.1 | 3766 | 4.2% |
| 8 | 5570 | |
| 7.9 | 2256 | 2.5% |
| 7.8 | 12069 |
cleanliness_score
Real number (ℝ)
High correlation
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2468521 |
| Minimum | 7.3 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 7.3 |
|---|---|
| 5-th percentile | 7.3 |
| Q1 | 8 |
| median | 8.2 |
| Q3 | 8.7 |
| 95-th percentile | 8.8 |
| Maximum | 9.1 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 0.44250269 |
|---|---|
| Coefficient of variation (CV) | 0.053657163 |
| Kurtosis | -0.33591991 |
| Mean | 8.2468521 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.17813145 |
| Sum | 738134.5 |
| Variance | 0.19580863 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 8.7 | 11852 | |
| 7.9 | 9854 | |
| 8.2 | 9297 | |
| 8.1 | 9000 | |
| 8.8 | 8716 | |
| 8 | 8484 | |
| 8.3 | 7670 | |
| 8.4 | 7286 | |
| 7.3 | 4621 | 5.2% |
| 9.1 | 4259 | 4.8% |
| Other values (4) | 8466 |
| Value | Count | Frequency (%) |
| 7.3 | 4621 | |
| 7.4 | 1876 | 2.1% |
| 7.5 | 1907 | 2.1% |
| 7.8 | 2681 | 3.0% |
| 7.9 | 9854 | |
| 8 | 8484 | |
| 8.1 | 9000 | |
| 8.2 | 9297 | |
| 8.3 | 7670 | |
| 8.4 | 7286 |
| Value | Count | Frequency (%) |
| 9.1 | 4259 | 4.8% |
| 8.8 | 8716 | |
| 8.7 | 11852 | |
| 8.5 | 2002 | 2.2% |
| 8.4 | 7286 | |
| 8.3 | 7670 | |
| 8.2 | 9297 | |
| 8.1 | 9000 | |
| 8 | 8484 | |
| 7.9 | 9854 |
comfort_score
Real number (ℝ)
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.2400223 |
| Minimum | 7.3 |
|---|---|
| Maximum | 9.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 7.3 |
|---|---|
| 5-th percentile | 7.3 |
| Q1 | 8 |
| median | 8.2 |
| Q3 | 8.7 |
| 95-th percentile | 8.9 |
| Maximum | 9.1 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 0.46634394 |
|---|---|
| Coefficient of variation (CV) | 0.056594985 |
| Kurtosis | -0.52072817 |
| Mean | 8.2400223 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.13031166 |
| Sum | 737523.2 |
| Variance | 0.21747667 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 8 | 12779 | |
| 7.9 | 9378 | |
| 8.2 | 8674 | |
| 8.1 | 8445 | |
| 8.8 | 8201 | |
| 7.3 | 6497 | |
| 8.3 | 6450 | |
| 8.9 | 6211 | |
| 8.5 | 5236 | 5.8% |
| 8.7 | 4392 | 4.9% |
| Other values (6) | 13242 |
| Value | Count | Frequency (%) |
| 7.3 | 6497 | |
| 7.4 | 1907 | 2.1% |
| 7.8 | 3294 | 3.7% |
| 7.9 | 9378 | |
| 8 | 12779 | |
| 8.1 | 8445 | |
| 8.2 | 8674 | |
| 8.3 | 6450 | |
| 8.4 | 1780 | 2.0% |
| 8.5 | 5236 |
| Value | Count | Frequency (%) |
| 9.1 | 2423 | 2.7% |
| 9 | 1836 | 2.1% |
| 8.9 | 6211 | |
| 8.8 | 8201 | |
| 8.7 | 4392 | |
| 8.6 | 2002 | 2.2% |
| 8.5 | 5236 | |
| 8.4 | 1780 | 2.0% |
| 8.3 | 6450 | |
| 8.2 | 8674 |
value_for_money_score
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7094911 |
| Minimum | 7 |
|---|---|
| Maximum | 8.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 7.4 |
| median | 7.7 |
| Q3 | 7.9 |
| 95-th percentile | 8.2 |
| Maximum | 8.3 |
| Range | 1.3 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.32641101 |
|---|---|
| Coefficient of variation (CV) | 0.042338853 |
| Kurtosis | -0.65862063 |
| Mean | 7.7094911 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.16088603 |
| Sum | 690038 |
| Variance | 0.10654415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 7.9 | 20241 | |
| 7.4 | 13180 | |
| 7.5 | 10425 | |
| 7.7 | 8546 | |
| 8.1 | 7952 | 8.9% |
| 7.6 | 7760 | 8.7% |
| 7.3 | 4746 | 5.3% |
| 7 | 4621 | 5.2% |
| 8.2 | 4392 | 4.9% |
| 8 | 4042 | 4.5% |
| Value | Count | Frequency (%) |
| 7 | 4621 | 5.2% |
| 7.3 | 4746 | 5.3% |
| 7.4 | 13180 | |
| 7.5 | 10425 | |
| 7.6 | 7760 | 8.7% |
| 7.7 | 8546 | |
| 7.9 | 20241 | |
| 8 | 4042 | 4.5% |
| 8.1 | 7952 | 8.9% |
| 8.2 | 4392 | 4.9% |
| Value | Count | Frequency (%) |
| 8.3 | 3600 | 4.0% |
| 8.2 | 4392 | 4.9% |
| 8.1 | 7952 | 8.9% |
| 8 | 4042 | 4.5% |
| 7.9 | 20241 | |
| 7.7 | 8546 | |
| 7.6 | 7760 | 8.7% |
| 7.5 | 10425 | |
| 7.4 | 13180 | |
| 7.3 | 4746 | 5.3% |
location_score
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1767086 |
| Minimum | 8.2 |
|---|---|
| Maximum | 9.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 8.2 |
|---|---|
| 5-th percentile | 8.6 |
| Q1 | 9 |
| median | 9.1 |
| Q3 | 9.4 |
| 95-th percentile | 9.6 |
| Maximum | 9.7 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.31118887 |
|---|---|
| Coefficient of variation (CV) | 0.033910728 |
| Kurtosis | 0.54790958 |
| Mean | 9.1767086 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -0.53207634 |
| Sum | 821361.3 |
| Variance | 0.096838514 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=11)
| Value | Count | Frequency (%) |
| 9.1 | 14059 | |
| 8.9 | 13828 | |
| 9 | 11122 | |
| 9.4 | 10530 | |
| 9.3 | 9270 | |
| 9.5 | 7290 | |
| 9.6 | 7055 | |
| 9.2 | 5657 | |
| 8.6 | 4395 | 4.9% |
| 9.7 | 4392 | 4.9% |
| Value | Count | Frequency (%) |
| 8.2 | 1907 | 2.1% |
| 8.6 | 4395 | 4.9% |
| 8.9 | 13828 | |
| 9 | 11122 | |
| 9.1 | 14059 | |
| 9.2 | 5657 | |
| 9.3 | 9270 | |
| 9.4 | 10530 | |
| 9.5 | 7290 | |
| 9.6 | 7055 |
| Value | Count | Frequency (%) |
| 9.7 | 4392 | 4.9% |
| 9.6 | 7055 | |
| 9.5 | 7290 | |
| 9.4 | 10530 | |
| 9.3 | 9270 | |
| 9.2 | 5657 | |
| 9.1 | 14059 | |
| 9 | 11122 | |
| 8.9 | 13828 | |
| 8.6 | 4395 | 4.9% |
Crawled_date
Date
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 699.4 KiB |
| Minimum | 2024-12-05 00:00:00 |
|---|---|
| Maximum | 2024-12-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=1)
title_length
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.1086308 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 7 |
| 95-th percentile | 15 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.8223059 |
|---|---|
| Coefficient of variation (CV) | 0.94395271 |
| Kurtosis | 2.0201067 |
| Mean | 5.1086308 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.4957671 |
| Sum | 457248 |
| Variance | 23.254634 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 1 | 24998 | |
| 2 | 15310 | |
| 4 | 6308 | 7.0% |
| 5 | 6208 | 6.9% |
| 6 | 5843 | 6.5% |
| 7 | 4767 | 5.3% |
| 3 | 4654 | 5.2% |
| 8 | 3866 | 4.3% |
| 9 | 3116 | 3.5% |
| 10 | 2491 | 2.8% |
| Other values (19) | 11944 |
| Value | Count | Frequency (%) |
| 1 | 24998 | |
| 2 | 15310 | |
| 3 | 4654 | 5.2% |
| 4 | 6308 | 7.0% |
| 5 | 6208 | 6.9% |
| 6 | 5843 | 6.5% |
| 7 | 4767 | 5.3% |
| 8 | 3866 | 4.3% |
| 9 | 3116 | 3.5% |
| 10 | 2491 | 2.8% |
| Value | Count | Frequency (%) |
| 29 | 2 | < 0.1% |
| 28 | 6 | < 0.1% |
| 27 | 19 | < 0.1% |
| 26 | 33 | < 0.1% |
| 25 | 86 | 0.1% |
| 24 | 171 | |
| 23 | 239 | |
| 22 | 284 | |
| 21 | 340 | |
| 20 | 419 |
text_length
Real number (ℝ)
High correlation
| Distinct | 408 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.369298 |
| Minimum | 1 |
|---|---|
| Maximum | 654 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 11 |
| median | 23 |
| Q3 | 47 |
| 95-th percentile | 111 |
| Maximum | 654 |
| Range | 653 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 40.564263 |
|---|---|
| Coefficient of variation (CV) | 1.1153436 |
| Kurtosis | 16.986613 |
| Mean | 36.369298 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | 3.1966573 |
| Sum | 3255234 |
| Variance | 1645.4594 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6 | 2601 | 2.9% |
| 5 | 2562 | 2.9% |
| 9 | 2531 | 2.8% |
| 7 | 2530 | 2.8% |
| 8 | 2495 | 2.8% |
| 10 | 2375 | 2.7% |
| 4 | 2341 | 2.6% |
| 11 | 2254 | 2.5% |
| 12 | 2248 | 2.5% |
| 14 | 2061 | 2.3% |
| Other values (398) | 65507 |
| Value | Count | Frequency (%) |
| 1 | 603 | 0.7% |
| 2 | 1263 | |
| 3 | 1844 | |
| 4 | 2341 | |
| 5 | 2562 | |
| 6 | 2601 | |
| 7 | 2530 | |
| 8 | 2495 | |
| 9 | 2531 | |
| 10 | 2375 |
| Value | Count | Frequency (%) |
| 654 | 1 | |
| 568 | 1 | |
| 527 | 1 | |
| 510 | 1 | |
| 503 | 1 | |
| 493 | 1 | |
| 491 | 1 | |
| 470 | 1 | |
| 469 | 1 | |
| 468 | 1 |
time_lapsed
Unsupported
Missing Rejected Unsupported
| Missing | 89505 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 699.4 KiB |
Deviation of star ratings
Real number (ℝ)
Zeros
| Distinct | 104 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3441741 |
| Minimum | 0 |
|---|---|
| Maximum | 7.7 |
| Zeros | 2451 |
| Zeros (%) | 2.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.4 |
| median | 1 |
| Q3 | 1.8 |
| 95-th percentile | 4 |
| Maximum | 7.7 |
| Range | 7.7 |
| Interquartile range (IQR) | 1.4 |
Descriptive statistics
| Standard deviation | 1.2904159 |
|---|---|
| Coefficient of variation (CV) | 0.96000655 |
| Kurtosis | 5.0862224 |
| Mean | 1.3441741 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | 2.0499369 |
| Sum | 120310.3 |
| Variance | 1.6651732 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.6 | 7297 | 8.2% |
| 0.4 | 7184 | 8.0% |
| 0.3 | 6728 | 7.5% |
| 1.4 | 4799 | 5.4% |
| 1.3 | 4293 | 4.8% |
| 0.7 | 4028 | 4.5% |
| 1 | 3906 | 4.4% |
| 1.6 | 3035 | 3.4% |
| 0.1 | 2979 | 3.3% |
| 2.3 | 2755 | 3.1% |
| Other values (94) | 42501 |
| Value | Count | Frequency (%) |
| 0 | 2451 | 2.7% |
| 0.1 | 2979 | |
| 0.2 | 589 | 0.7% |
| 0.2 | 2535 | 2.8% |
| 0.3 | 6728 | |
| 0.3 | 2118 | 2.4% |
| 0.4 | 7184 | |
| 0.5 | 894 | 1.0% |
| 0.6 | 7297 | |
| 0.6 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 7.7 | 15 | < 0.1% |
| 7.6 | 16 | < 0.1% |
| 7.4 | 92 | 0.1% |
| 7.3 | 52 | 0.1% |
| 7.2 | 8 | < 0.1% |
| 7.1 | 66 | 0.1% |
| 7 | 86 | 0.1% |
| 6.9 | 113 | 0.1% |
| 6.8 | 146 | 0.2% |
| 6.7 | 432 |
FOG Index
Real number (ℝ)
High correlation
| Distinct | 1977 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.6674118 |
| Minimum | 0 |
|---|---|
| Maximum | 142.24 |
| Zeros | 4 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.8 |
| Q1 | 6.61 |
| median | 8.51 |
| Q3 | 11.6 |
| 95-th percentile | 18.68 |
| Maximum | 142.24 |
| Range | 142.24 |
| Interquartile range (IQR) | 4.99 |
Descriptive statistics
| Standard deviation | 5.3495303 |
|---|---|
| Coefficient of variation (CV) | 0.55335704 |
| Kurtosis | 18.277331 |
| Mean | 9.6674118 |
| Median Absolute Deviation (MAD) | 2.43 |
| Skewness | 2.6388406 |
| Sum | 865281.69 |
| Variance | 28.617475 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8.04 | 2075 | 2.3% |
| 10 | 1943 | 2.2% |
| 9.07 | 1532 | 1.7% |
| 11.6 | 1457 | 1.6% |
| 8.51 | 1441 | 1.6% |
| 8.2 | 1408 | 1.6% |
| 8 | 1167 | 1.3% |
| 14.53 | 1009 | 1.1% |
| 13.2 | 865 | 1.0% |
| 8.13 | 802 | 0.9% |
| Other values (1967) | 75806 |
| Value | Count | Frequency (%) |
| 0 | 4 | < 0.1% |
| 0.4 | 230 | 0.3% |
| 0.8 | 421 | |
| 1 | 15 | < 0.1% |
| 1.08 | 1 | < 0.1% |
| 1.2 | 614 | |
| 1.32 | 7 | < 0.1% |
| 1.4 | 48 | 0.1% |
| 1.48 | 14 | < 0.1% |
| 1.52 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 142.24 | 1 | < 0.1% |
| 106.39 | 1 | < 0.1% |
| 104.98 | 1 | < 0.1% |
| 86.1 | 1 | < 0.1% |
| 84.97 | 1 | < 0.1% |
| 80.4 | 4 | |
| 74.51 | 1 | < 0.1% |
| 72.32 | 1 | < 0.1% |
| 66 | 1 | < 0.1% |
| 65.48 | 1 | < 0.1% |
Flesch Reading Ease
Real number (ℝ)
High correlation
| Distinct | 2213 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 65.935566 |
| Minimum | -555.59 |
|---|---|
| Maximum | 206.84 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2352 |
| Negative (%) | 2.6% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | -555.59 |
|---|---|
| 5-th percentile | 22.07 |
| Q1 | 57.61 |
| median | 71.82 |
| Q3 | 81.29 |
| 95-th percentile | 93.81 |
| Maximum | 206.84 |
| Range | 762.43 |
| Interquartile range (IQR) | 23.68 |
Descriptive statistics
| Standard deviation | 28.977276 |
|---|---|
| Coefficient of variation (CV) | 0.43947868 |
| Kurtosis | 36.546657 |
| Mean | 65.935566 |
| Median Absolute Deviation (MAD) | 10.99 |
| Skewness | -4.1884291 |
| Sum | 5901562.8 |
| Variance | 839.6825 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 68.77 | 761 | 0.9% |
| 73.85 | 732 | 0.8% |
| 79.26 | 727 | 0.8% |
| 71.82 | 715 | 0.8% |
| 81.29 | 703 | 0.8% |
| 80.28 | 675 | 0.8% |
| 56.93 | 671 | 0.7% |
| 64.37 | 666 | 0.7% |
| 78.25 | 642 | 0.7% |
| 66.4 | 637 | 0.7% |
| Other values (2203) | 82576 |
| Value | Count | Frequency (%) |
| -555.59 | 1 | < 0.1% |
| -470.99 | 2 | < 0.1% |
| -386.39 | 4 | < 0.1% |
| -301.79 | 39 | < 0.1% |
| -265.85 | 1 | < 0.1% |
| -260.5 | 1 | < 0.1% |
| -219.22 | 1 | < 0.1% |
| -218.2 | 4 | < 0.1% |
| -217.19 | 98 | |
| -177.93 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 206.84 | 4 | < 0.1% |
| 121.22 | 99 | |
| 120.21 | 146 | |
| 119.19 | 149 | |
| 118.68 | 1 | < 0.1% |
| 118.18 | 116 | |
| 117.67 | 4 | < 0.1% |
| 117.16 | 102 | |
| 116.86 | 1 | < 0.1% |
| 116.65 | 6 | < 0.1% |
depth
Real number (ℝ)
High correlation
| Distinct | 83186 |
|---|---|
| Distinct (%) | 92.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54634223 |
| Minimum | 8.1881423 × 10-18 |
|---|---|
| Maximum | 1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 8.1881423 × 10-18 |
|---|---|
| 5-th percentile | 0.13008598 |
| Q1 | 0.43244792 |
| median | 0.57926209 |
| Q3 | 0.69164551 |
| 95-th percentile | 0.82170573 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.25919759 |
Descriptive statistics
| Standard deviation | 0.20551205 |
|---|---|
| Coefficient of variation (CV) | 0.37615992 |
| Kurtosis | 0.23724848 |
| Mean | 0.54634223 |
| Median Absolute Deviation (MAD) | 0.12705512 |
| Skewness | -0.64161322 |
| Sum | 48900.361 |
| Variance | 0.042235201 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1130 | 1.3% |
| 0.004922022706 | 217 | 0.2% |
| 9.745073011 × 10-18 | 124 | 0.1% |
| 2.018798838 × 10-17 | 98 | 0.1% |
| 0.04049735227 | 93 | 0.1% |
| 0.2797303972 | 90 | 0.1% |
| 0.1984465399 | 80 | 0.1% |
| 1.13798216 × 10-17 | 77 | 0.1% |
| 1.026030482 × 10-17 | 77 | 0.1% |
| 9.690374166 × 10-18 | 67 | 0.1% |
| Other values (83176) | 87452 |
| Value | Count | Frequency (%) |
| 8.188142263 × 10-18 | 31 | < 0.1% |
| 9.690374166 × 10-18 | 67 | |
| 9.745073011 × 10-18 | 124 | |
| 9.88963349 × 10-18 | 1 | < 0.1% |
| 1.026030482 × 10-17 | 77 | |
| 1.029177741 × 10-17 | 1 | < 0.1% |
| 1.042035196 × 10-17 | 38 | < 0.1% |
| 1.13798216 × 10-17 | 77 | |
| 1.148738186 × 10-17 | 60 | |
| 1.29645455 × 10-17 | 23 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1130 | |
| 0.9715296611 | 1 | < 0.1% |
| 0.9618646312 | 1 | < 0.1% |
| 0.9610171493 | 1 | < 0.1% |
| 0.9609511965 | 1 | < 0.1% |
| 0.960657503 | 1 | < 0.1% |
| 0.9604759833 | 1 | < 0.1% |
| 0.958671232 | 1 | < 0.1% |
| 0.9564162594 | 1 | < 0.1% |
| 0.9563900494 | 1 | < 0.1% |
breadth
Real number (ℝ)
High correlation
| Distinct | 82983 |
|---|---|
| Distinct (%) | 92.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.58197322 |
| Minimum | 0.032643992 |
|---|---|
| Maximum | 1.6701841 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 699.4 KiB |
Quantile statistics
| Minimum | 0.032643992 |
|---|---|
| 5-th percentile | 0.2625099 |
| Q1 | 0.41224664 |
| median | 0.54627955 |
| Q3 | 0.71761788 |
| 95-th percentile | 1.0427207 |
| Maximum | 1.6701841 |
| Range | 1.6375401 |
| Interquartile range (IQR) | 0.30537124 |
Descriptive statistics
| Standard deviation | 0.24160824 |
|---|---|
| Coefficient of variation (CV) | 0.41515354 |
| Kurtosis | 0.92029194 |
| Mean | 0.58197322 |
| Median Absolute Deviation (MAD) | 0.14945944 |
| Skewness | 0.75969015 |
| Sum | 52089.513 |
| Variance | 0.058374542 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.03264399233 | 1130 | 1.3% |
| 1.099357789 | 217 | 0.2% |
| 1.214987768 | 124 | 0.1% |
| 1.311139496 | 115 | 0.1% |
| 1.154836459 | 107 | 0.1% |
| 1.097742411 | 93 | 0.1% |
| 0.7213535527 | 90 | 0.1% |
| 1.248862421 | 86 | 0.1% |
| 0.7323408524 | 80 | 0.1% |
| 1.177459644 | 78 | 0.1% |
| Other values (82973) | 87385 |
| Value | Count | Frequency (%) |
| 0.03264399233 | 1130 | |
| 0.08893883701 | 1 | < 0.1% |
| 0.09023753393 | 1 | < 0.1% |
| 0.09239464589 | 1 | < 0.1% |
| 0.100507054 | 1 | < 0.1% |
| 0.1009408479 | 1 | < 0.1% |
| 0.1025939613 | 1 | < 0.1% |
| 0.1029072035 | 1 | < 0.1% |
| 0.1036846073 | 1 | < 0.1% |
| 0.1063368268 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.670184096 | 49 | |
| 1.667293504 | 1 | < 0.1% |
| 1.664931359 | 2 | < 0.1% |
| 1.662843386 | 1 | < 0.1% |
| 1.659240055 | 1 | < 0.1% |
| 1.656232367 | 1 | < 0.1% |
| 1.6539588 | 1 | < 0.1% |
| 1.647175179 | 1 | < 0.1% |
| 1.645908958 | 1 | < 0.1% |
| 1.630870649 | 1 | < 0.1% |
Interactions
Correlations
| Average_Rating | Deviation of star ratings | FOG Index | Flesch Reading Ease | Helpfulness | Hotel_Name | Num_of_Ratings | Rating | breadth | cleanliness_score | comfort_score | depth | employee_friendliness_score | facility_score | hotel_grade | is_photo | location_score | text_length | title_length | value_for_money_score | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Average_Rating | 1.000 | -0.005 | 0.002 | -0.039 | -0.020 | 1.000 | -0.323 | 0.281 | 0.009 | 0.919 | 0.883 | 0.010 | 0.844 | 0.941 | 0.504 | 0.067 | 0.156 | -0.035 | 0.007 | 0.709 |
| Deviation of star ratings | -0.005 | 1.000 | -0.007 | 0.010 | -0.042 | 0.184 | -0.098 | -0.041 | -0.001 | 0.009 | 0.005 | -0.053 | 0.023 | 0.023 | 0.124 | 0.035 | -0.103 | 0.044 | -0.092 | 0.008 |
| FOG Index | 0.002 | -0.007 | 1.000 | -0.749 | -0.003 | 0.014 | 0.030 | 0.010 | 0.053 | -0.003 | 0.003 | -0.053 | 0.001 | 0.000 | 0.009 | 0.022 | 0.034 | -0.103 | 0.024 | -0.023 |
| Flesch Reading Ease | -0.039 | 0.010 | -0.749 | 1.000 | 0.027 | 0.023 | -0.010 | -0.105 | -0.126 | -0.028 | -0.034 | 0.095 | -0.040 | -0.034 | 0.013 | 0.027 | -0.026 | 0.301 | 0.011 | -0.002 |
| Helpfulness | -0.020 | -0.042 | -0.003 | 0.027 | 1.000 | 0.032 | 0.001 | -0.081 | -0.077 | -0.012 | -0.009 | 0.054 | -0.036 | -0.013 | 0.012 | 0.019 | -0.018 | 0.119 | 0.030 | -0.006 |
| Hotel_Name | 1.000 | 0.184 | 0.014 | 0.023 | 0.032 | 1.000 | 1.000 | 0.153 | 0.034 | 1.000 | 1.000 | 0.046 | 1.000 | 1.000 | 1.000 | 0.134 | 1.000 | 0.022 | 0.035 | 1.000 |
| Num_of_Ratings | -0.323 | -0.098 | 0.030 | -0.010 | 0.001 | 1.000 | 1.000 | -0.080 | 0.004 | -0.366 | -0.248 | 0.009 | -0.307 | -0.335 | 0.606 | 0.111 | 0.375 | 0.003 | 0.016 | -0.374 |
| Rating | 0.281 | -0.041 | 0.010 | -0.105 | -0.081 | 0.153 | -0.080 | 1.000 | 0.081 | 0.265 | 0.264 | -0.006 | 0.250 | 0.273 | 0.129 | 0.065 | 0.066 | -0.188 | -0.006 | 0.197 |
| breadth | 0.009 | -0.001 | 0.053 | -0.126 | -0.077 | 0.034 | 0.004 | 0.081 | 1.000 | 0.006 | 0.004 | -0.711 | 0.006 | 0.008 | 0.007 | 0.067 | 0.001 | -0.621 | -0.153 | -0.003 |
| cleanliness_score | 0.919 | 0.009 | -0.003 | -0.028 | -0.012 | 1.000 | -0.366 | 0.265 | 0.006 | 1.000 | 0.961 | 0.016 | 0.837 | 0.952 | 0.536 | 0.072 | 0.093 | -0.023 | 0.006 | 0.740 |
| comfort_score | 0.883 | 0.005 | 0.003 | -0.034 | -0.009 | 1.000 | -0.248 | 0.264 | 0.004 | 0.961 | 1.000 | 0.024 | 0.810 | 0.943 | 0.483 | 0.061 | 0.112 | -0.020 | 0.010 | 0.646 |
| depth | 0.010 | -0.053 | -0.053 | 0.095 | 0.054 | 0.046 | 0.009 | -0.006 | -0.711 | 0.016 | 0.024 | 1.000 | 0.018 | 0.010 | 0.015 | 0.055 | 0.013 | 0.493 | 0.139 | 0.016 |
| employee_friendliness_score | 0.844 | 0.023 | 0.001 | -0.040 | -0.036 | 1.000 | -0.307 | 0.250 | 0.006 | 0.837 | 0.810 | 0.018 | 1.000 | 0.816 | 0.425 | 0.090 | 0.109 | -0.033 | 0.017 | 0.683 |
| facility_score | 0.941 | 0.023 | 0.000 | -0.034 | -0.013 | 1.000 | -0.335 | 0.273 | 0.008 | 0.952 | 0.943 | 0.010 | 0.816 | 1.000 | 0.653 | 0.069 | 0.064 | -0.030 | -0.003 | 0.693 |
| hotel_grade | 0.504 | 0.124 | 0.009 | 0.013 | 0.012 | 1.000 | 0.606 | 0.129 | 0.007 | 0.536 | 0.483 | 0.015 | 0.425 | 0.653 | 1.000 | 0.061 | 0.426 | 0.015 | 0.010 | 0.336 |
| is_photo | 0.067 | 0.035 | 0.022 | 0.027 | 0.019 | 0.134 | 0.111 | 0.065 | 0.067 | 0.072 | 0.061 | 0.055 | 0.090 | 0.069 | 0.061 | 1.000 | 0.060 | 0.098 | 0.059 | 0.062 |
| location_score | 0.156 | -0.103 | 0.034 | -0.026 | -0.018 | 1.000 | 0.375 | 0.066 | 0.001 | 0.093 | 0.112 | 0.013 | 0.109 | 0.064 | 0.426 | 0.060 | 1.000 | 0.005 | 0.058 | 0.019 |
| text_length | -0.035 | 0.044 | -0.103 | 0.301 | 0.119 | 0.022 | 0.003 | -0.188 | -0.621 | -0.023 | -0.020 | 0.493 | -0.033 | -0.030 | 0.015 | 0.098 | 0.005 | 1.000 | 0.224 | -0.015 |
| title_length | 0.007 | -0.092 | 0.024 | 0.011 | 0.030 | 0.035 | 0.016 | -0.006 | -0.153 | 0.006 | 0.010 | 0.139 | 0.017 | -0.003 | 0.010 | 0.059 | 0.058 | 0.224 | 1.000 | 0.005 |
| value_for_money_score | 0.709 | 0.008 | -0.023 | -0.002 | -0.006 | 1.000 | -0.374 | 0.197 | -0.003 | 0.740 | 0.646 | 0.016 | 0.683 | 0.693 | 0.336 | 0.062 | 0.019 | -0.015 | 0.005 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Hotel_Name | Review_Text | Posted_Date | Rating | Average_Rating | Num_of_Ratings | Helpfulness | is_photo | review_title | hotel_grade | employee_friendliness_score | facility_score | cleanliness_score | comfort_score | value_for_money_score | location_score | Crawled_date | title_length | text_length | time_lapsed | Deviation of star ratings | FOG Index | Flesch Reading Ease | depth | breadth | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | studios2let | Perfect location with good connections and shops and pubs | NaN | 10.0 | 7.6 | 11670 | 0 | 0 | Exceptional | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 1 | 9 | NaN | 2.4 | 12.49 | 62.34 | 0.416557 | 0.843382 |
| 1 | studios2let | The room had everything you needed. Near to amenities, was good room for price just needs little updatingThe bed was so hard it felt like sleeping on a hard floor, you had to make sure you had something on your feet as flooring pinched you feet needs changing | NaN | 8.0 | 7.6 | 11670 | 0 | 0 | Very good | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 2 | 48 | NaN | 0.4 | 10.43 | 80.96 | 0.578633 | 0.431915 |
| 2 | studios2let | Conveniently nearby St. Pancras, very small but clean and pleasant room (first floor with small balcony to street side). Interesting area.Luggage service can be improved by offering to lock luggage up instead of it just being put into the hall with all risks on the guests. | NaN | 8.0 | 7.6 | 11670 | 0 | 0 | Convenient location | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 2 | 46 | NaN | 0.4 | 7.86 | 72.87 | 0.577259 | 0.487019 |
| 3 | studios2let | Reception staffed 24 hours a day.All good. | NaN | 9.0 | 7.6 | 11670 | 0 | 0 | Peaceful position in an elegant street close to 3 major stations and the Bloomsbury area. | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 15 | 7 | NaN | 1.4 | 8.51 | 81.29 | 0.354681 | 0.701785 |
| 4 | studios2let | Very convenient to Kings Cross and the cityA little dated could do with a lick of paint | NaN | 8.0 | 7.6 | 11670 | 0 | 0 | Great little gem in the city centre | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 7 | 17 | NaN | 0.4 | 9.15 | 88.06 | 0.681863 | 0.838373 |
| 5 | studios2let | Located in a quiet area but close to Kings Cross station so getting around was easy. Several little pubs nearby for dining and some good coffee shops too.There is no lift so dragging a heavy suitcase up and down stairs was challenging. We had booked a room with terrace but the outdoor space was really minuscule - not what we had expected from the photos. | NaN | 7.0 | 7.6 | 11670 | 0 | 0 | Convenient, quiet location. | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 3 | 65 | NaN | 0.6 | 8.90 | 72.16 | 0.579746 | 0.430384 |
| 6 | studios2let | It's spacious, good value and so very quiet for London.You sometimes have to wriggle the loo flusher to stop it running and running | NaN | 9.0 | 7.6 | 11670 | 0 | 0 | Superb | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 1 | 23 | NaN | 1.4 | 4.60 | 76.72 | 0.472033 | 0.467403 |
| 7 | studios2let | LocationLot of stairs (bad knee) | NaN | 9.0 | 7.6 | 11670 | 0 | 0 | Ideal location for travelling round | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 5 | 5 | NaN | 1.4 | 10.00 | 66.40 | 0.451154 | 0.379700 |
| 8 | studios2let | Location was great, so near the stationWe were on the top floor, six flights of stairs and no lift.\nHeating was on 247 full temperature and no means of reducing it! | NaN | 7.0 | 7.6 | 11670 | 0 | 0 | Perfect location, | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 2 | 31 | NaN | 0.6 | 11.36 | 81.12 | 0.507467 | 0.499533 |
| 9 | studios2let | The location which is excellent for public transport and local dining. \nFriendly staffed reception where we could leave our travel bags all day after checking out.The climb up 3 flights of stairs was exhausting but it was our choice.\nIt was a small room and the kitchen facilities were very sparse ( but we didn't need them) | NaN | 8.0 | 7.6 | 11670 | 0 | 0 | Ideal accommodation for a short stay in London near St Pancreas station | 3 | 8.3 | 7.5 | 7.9 | 7.8 | 7.6 | 9.3 | 2024-12-05 | 12 | 57 | NaN | 0.4 | 9.17 | 74.19 | 0.776267 | 0.430035 |
| Hotel_Name | Review_Text | Posted_Date | Rating | Average_Rating | Num_of_Ratings | Helpfulness | is_photo | review_title | hotel_grade | employee_friendliness_score | facility_score | cleanliness_score | comfort_score | value_for_money_score | location_score | Crawled_date | title_length | text_length | time_lapsed | Deviation of star ratings | FOG Index | Flesch Reading Ease | depth | breadth | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89495 | montanahotel | The hotel was lovely, very clean and tidy. The perfect location for me and my partner as we wanted to stay in Kensington and its very close to Knightsbridge. \nStaff were very friendly super helpful. we did feel a little rushed in the restaurant however we did arriving quite close to closing time. Would most definitely stay again or recommend to family and friends.We didnt have to complain about anything. | NaN | 9.0 | 7.8 | 6248 | 0 | 0 | Christmas break | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 2 | 70 | NaN | 1.2 | 7.54 | 76.52 | 0.558821 | 0.317196 |
| 89496 | montanahotel | Everything we needed in the room ,lovely breakfast, excellent location next to tube station and lots of restaurants.The room was too hot.which made it uncomfortable to sleep .Room 509. | NaN | 10.0 | 7.8 | 6248 | 1 | 0 | Great location | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 2 | 29 | NaN | 2.2 | 8.02 | 70.09 | 0.633815 | 0.552477 |
| 89497 | montanahotel | locationhot room, shower didnt drain, broken sink | NaN | 5.0 | 7.8 | 6248 | 0 | 0 | Great location and generally clean spot but the place is a bit a dated and the basement room was damp, hot and a bit mus | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 25 | 7 | NaN | 2.8 | 8.51 | 38.99 | 0.122524 | 0.892616 |
| 89498 | montanahotel | Good to have teacoffee and a fridge in the room.The building is beautiful but the interior decor leaves a lot to be desired. The hotel is Indian in style...redgold...faded wallpaper and threadbare carpets...the room was OK but again needed updating. We were in the basement with no view...only rubbish out of the window. There was no hot breakfast so only cereals, fruit and pastries...but it was in a pleasant location...near the tube and shopspubs etc...only a short walk to the Natural History museum. | NaN | 6.0 | 7.8 | 6248 | 0 | 0 | Lovely building with quite a grand entrance...let down by the interior...fine for overnight stay. | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 14 | 83 | NaN | 1.8 | 6.86 | 63.86 | 0.681369 | 0.280244 |
| 89499 | montanahotel | locationwater pressure was non existent.\ndespite several request to address the problem. | NaN | 3.0 | 7.8 | 6248 | 0 | 0 | while the staff was nice. They did very little to remedy the lack of shower and hot water problem we had . | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 22 | 12 | NaN | 4.8 | 9.07 | 23.09 | 0.474054 | 0.459680 |
| 89500 | montanahotel | Convenient and classy. The staff are excellent people, and Light of India is a fantastic restaurant. I would certainly stay again.NA | NaN | 10.0 | 7.8 | 6248 | 0 | 0 | Highly recommend this little gem situated in my favourite part of town. | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 12 | 21 | NaN | 2.2 | 8.51 | 64.37 | 0.648530 | 0.484818 |
| 89501 | montanahotel | lovely atmosphere, extremely friendly and helpful staff. | NaN | 10.0 | 7.8 | 6248 | 0 | 0 | Perfect location for our visit to the Royal Albert Hall and the Natural History Museum. would | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 16 | 7 | NaN | 2.2 | 14.23 | 30.53 | 0.212149 | 0.927852 |
| 89502 | montanahotel | It was a single room, a little small but it was fine for 1 person, it had everything I needed | NaN | 10.0 | 7.8 | 6248 | 0 | 1 | The staff were very friendly and helpful. The position was perfect for sightseeing | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 13 | 20 | NaN | 2.2 | 8.00 | 76.56 | 0.325873 | 0.795743 |
| 89503 | montanahotel | Very clean and well maintained.The rooms are very nice and comfortable with staffs professionalism.The food are delicious,nice breakfast,lunch ,dinner and the cocktails are exceptional.Notting much just that theres no parking. | NaN | 10.0 | 7.8 | 6248 | 0 | 1 | Myself and my wife really enjoy our stay at this hotel,we love the service and all the staffs are amazing.Looking forwar | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 21 | 30 | NaN | 2.2 | 8.33 | 63.86 | 0.553296 | 0.669632 |
| 89504 | montanahotel | The staff were very friendly and helpful! Especially Kampas The hotel was very clean and the fact that they had a wonderful Indian restaurant as part of it was amazing. Best Vindaloo ever!!!!Shower a tad small but adequate xx | NaN | 10.0 | 7.8 | 6248 | 0 | 1 | Loved every minute! we will be back!! Xxx | 3 | 9.0 | 7.7 | 8.2 | 8.2 | 8.0 | 9.4 | 2024-12-05 | 8 | 39 | NaN | 2.2 | 5.97 | 69.99 | 0.593370 | 0.478818 |